So when I create in my charts you'll recall my first steps I selected the data I went to insert and
I answered in my chart.
Where did my chart show up.
Yeah it showed up on the existing sheet the active sheet.
So I got my spreadsheet and the chart on one sheet.
This is great because now I got that spreadsheet up above the actual data and the chart down below.
And we can compare between the two easy and accessible but by doing this my chart it might take up too
much space and might cover something up there in two different spots.
It's just maybe maybe too much clutter in one spot.
What I'd like to do is take the chart and put it on its own worksheet get a much larger charted out
there where I can manage that chart all by itself.
Take a look.
This is a quick simple change here.
One little change move the chart to its own sheet.
Watch this.
So I'm going to slide my chart.
That's the first step.
Anytime you're ever going to manipulate the chart.
Make sure you select the chart with it selected.
I'll go to my Design tab top of my screen on the far right it's you got move charts.
I'll give that a click.
I'm going to change it from an object in which is currently inside of my quarter one sheet to its new
sheet its own sheet and I'll give this a name.
This will be the month the budget charts and I'll hit OK.
And now I've got a brand new sheet their monthly budget chart and it's got the chart all by itself.
A nice big chart where I can format it maybe make the numbers bigger and I can grab this.
What is that.
The blue the phones and I can make those numbers bigger it's going to my home tabun bumped that up a
few adds up to like 12 and make that bold.
You know I can really start to maintain this chart all by itself.
It's on it's own sheets.
Nothing else to pump into and cover up.
And now I got a much more real estate much more space inside of there to start to make things a little
more separation and a little bit larger.
So try this out one simple little change.
Select your chart.
Go to the Design tab far right you'll find.
Move chart in location and put it on its own sheet.
There you have it.
Try it out.